SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=4 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+science +stuff +for +sale' IN BOOLEAN MODE)) AND iCityID IN (5735,6184,5606,5689,5594,5670,5495,6228,6266,5891,5644,5799,6105,5833,5488,5681,5560,5772,16524,5997,5808,5607,6251,6097,5871,6823,5729,5470,5469,5749,5442,5609,6215,6030,5755,5516,6162,5828,5627,6235,6000,6126,5590,5746,5899,5771,6003,5626,5637,5692,6096,6142,16527,5701,6056,5690,6104,5649,5837,16526,16528,5647,16529,6052,6267,5875,6037,5991,16115,6094,5672,5850,5849,5655,5564,6270,5877,5711,6040,6163,5927,5474,5475,6076,5450,6091,5633,5528,5477,5976,6032,5677,6125,5504,5800,6093,5721,5620,6119,5523,5480,5953,5676,6141,5880,6018,5547,5915,6002,6129,6200,5955,6296,5566,5942,6045,6086,6281,5914,5447,6242,6191,6279,5758,6109,5634,16530,5684,5454,5825,6153,5691,6074,5885,5949,5464,5793,5832,6252,5744,5683,5599,5943,5985,5615,5463,6024,5722,6120,6253,5531,6204,5584,5595,6240,5682,5873,5824,5456,5731,16598,5704,5788,6211,5575,5980,6121,5898,5668) ORDER BY FIELD(iCityID, 5735,6184,5606,5689,5594,5670,5495,6228,6266,5891,5644,5799,6105,5833,5488,5681,5560,5772,16524,5997,5808,5607,6251,6097,5871,6823,5729,5470,5469,5749,5442,5609,6215,6030,5755,5516,6162,5828,5627,6235,6000,6126,5590,5746,5899,5771,6003,5626,5637,5692,6096,6142,16527,5701,6056,5690,6104,5649,5837,16526,16528,5647,16529,6052,6267,5875,6037,5991,16115,6094,5672,5850,5849,5655,5564,6270,5877,5711,6040,6163,5927,5474,5475,6076,5450,6091,5633,5528,5477,5976,6032,5677,6125,5504,5800,6093,5721,5620,6119,5523,5480,5953,5676,6141,5880,6018,5547,5915,6002,6129,6200,5955,6296,5566,5942,6045,6086,6281,5914,5447,6242,6191,6279,5758,6109,5634,16530,5684,5454,5825,6153,5691,6074,5885,5949,5464,5793,5832,6252,5744,5683,5599,5943,5985,5615,5463,6024,5722,6120,6253,5531,6204,5584,5595,6240,5682,5873,5824,5456,5731,16598,5704,5788,6211,5575,5980,6121,5898,5668) ASC, p.tmPosted DESC LIMIT 24 science stuff for sale, For Sale Classifieds, Buy Used, Electronics, Computers, Tablets, Mobiles in Grapevine

Items for sale in Grapevine - science stuff for sale

No results found!

Looking for something? Get notified when it's posted. Setup an Email Alert now!

Grapevine

Items for Sale

Items for sale in Grapevine - science stuff for sale

Similar searches: